﻿IF object_id(N'dbo.UDS_Task_Comment', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_Task_Comment] (
        [ID]         int          NOT NULL identity(1, 1),
        [TaskID]     int          NULL,
        [Username]   nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Comment]    nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
        [SubmitTime] datetime     NULL CONSTRAINT [DF_UDS_Task_Comment_SubmitTime] default((getdate())),

        CONSTRAINT [PK_UDS_Task_Comment] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
